﻿CREATE PROCEDURE [dbo].[usp_UserDealerAddress_Tbl_Ins] 
@Department nvarchar(50), 
@Company nvarchar(255), 
@Line1 nvarchar(50), 
@Line2 nvarchar(50), 
@Line3 nvarchar(50), 
@Line4 nvarchar(50), 
@CountryID int, 
@MainPhone nvarchar(50), 
@MainEmail nvarchar(50), 
@MainFax nvarchar(50), 
@MainWWW nvarchar(50)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
INSERT INTO UserDealerAddress_Tbl (Department, Company, Line1, Line2, Line3, Line4, CountryID, MainPhone, MainFax, MainEmail, MainWWW) VALUES (@Department, @Company, @Line1, @Line2, @Line3, @Line4, @CountryID, @MainPhone, @MainFax, @MainEmail,  @MainWWW)
END